home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Night Owl 6
/
Night Owl's Shareware - PDSI-006 - Night Owl Corp (1990).iso
/
007a
/
bikelog1.zip
/
BIKELOG.DOC
next >
Wrap
Text File
|
1991-12-03
|
12KB
|
307 lines
╔═══════════════════════════════════════════════════════════╗
║ INTRO ║
╚═══════════════════════════════════════════════════════════╝
These are the docs to BIKELOG, a Lotus worksheet with
extensive macros that logs bike training info. It will record all
bike travel info (trip lenghth, time, avg speed, weather, etc.) and
calculate various info from this. Also, bikelog will calculate the
calories burned (based on a formula in MAY 89 Bicycling magazine
article by James Hagberg). Running the worksheet is self evident
with the information in this doc file and a general knowledge of
Lotus 123. The macro was written in Lotus 123 v2.2. I don't know
if certain macro features are used in Bikelog and not available in
previous versions (although I suspect they are not and previous
versions will run Bikelog).
╔═════════════════════════════════════════════════════════════╗
║ EXPLANATION OF SHAREWARE ║
╚═════════════════════════════════════════════════════════════╝
This program is being distributed as SHAREWARE. What
this means is that you are free to run this program on your
computer for your own personal evaluation for a period of 30
days. After this 30 day period you must either erase your copy of
the program, or registration the software. This can be done by
sending your name and address to the author along with a $5.00
registration fee. Shareware allows you to try out software
without the expense involved in traditional retail purchase. If
you don't like it, don't buy it. By the same token, if you find
it useful and continue to use it, you are obligated to send your
payment of $5.00 to the author at the address following address.
John Durso
16 Eliot Rd.
Needham, Ma 02194
Thank-you for your support of SHAREWARE!
NOW THE LEGAL STUFF.
DISCLAIMER: John Durso, nor any party affiliated with him,
will assume any responsibility for any problems which
occur as a result, be it direct, or indirect, of using
the BIKELOG program. By using, THE USER ASSUMES ALL RISKS
WHICH ARE INVOLVED THROUGH THE USE OF THESE PROGRAMS. There
are no warrantees whatsoever, expressed or implied, as
to the usefulness or effectiveness of this program for
any particular purpose. This software is sold as is,
and is not guaranteed to work on any particular machine,
or any particular hardware configuration. Use of this
software constitutes immediate acceptance of these terms by
the user.
╔═════════════════════════════════════════════════════════════╗
║ SUPPORT, QUESTIONS, COMMENTS ║
╚═════════════════════════════════════════════════════════════╝
I can be reached by mail at the above address. Also, I monitor
the Bicycling conferences on RIME (Relaynet) and FIDO.
╔═════════════════════════════════════════════════════════════╗
║ GETTING STARTED ║
╚═════════════════════════════════════════════════════════════╝
First BACKUP THE PROGRAM.
Second, put BIKELOG.WK1 into the directory where your Lotus
Worksheet files reside. Call up BIKELOG like you would any other
worksheet.
┌───────────────────────┐
│ADD-INS & BATCH RUNNING│
└───────────────────────┘
I've written Bikelog to run from a auto boot macro. When you load
the worksheet, it automatically calls up the macro. Also, I run
Bikelog with all Add-Ins removed to free up as much memory as
possible (since no Add-Ins are needed to run Bikelog. I do this
through a key stacking program (I recommend STACKEY) from a batch
file that calls up lotus 123 and sends the following string of keys
to lotus:
/ACQ/FRBIKELOG
The first part removes any add-ins (this is not needed if you don't
have add ins or you have lots of memory) and the second calls up
the bikelog worksheet.
┌──────────┐
│AVG SPEED │
└──────────┘
My trip computer calculates AVG SPEED. Bikelog is currently set up
to just use this value. If your cyclocomputer will not calculate
this, you can have bikelog calculate it by doing the following:
1) In D2 add the following formula
+B2/((Q2)+(R2/60))
2) Move range AS18-AS23 to AS17-AS22 (essentially removing AS18)
┌────────────────────────────┐
│FROM, TO, ROUTE, & BIKE INFO│
└────────────────────────────┘
Bikelog will allow you to add starting destination, ending
destination (usually the same if round trip), Route traveled, and
bike used.
NOTE: THE MAXIMUM ALLOWED IS 8 IN EACH CATEGORY (the last
one should remain OTHER though since this is the one that
allows the editing from the macros). ALSO, KEEP
DESCRIPTIONS SHORT SO THEY WILL NOT OVERFLOW RANGES WHEN
PRINTING.
Bikelog will allow you to add new values for the above four ranges
from the macro, but deletions will have to be done manually (just
go to the sections (which follow) and move the columns of data that
you want to keep over to the left. Note: Each of the four ranges
(Starting and ending Destinations, Route, and Bike) has 4 or five
rows. Move all rows associated with each values columns.
Ex. If you want to remove a BIKE.
┌──Bike to remove.
BIKE │
AAAA BBBBB CCCCC DDDDDD OTHER
XXXX XXXXX XXXXX XXXXXX XXXXXXX
XXXX XXXXX XXXXX XXXXXX XXXXXXX
XXXX XXXXX XXXXX XXXXXX XX│XXXX
│ │
Move these ─┴───────┘
two columns
over to the left one row to get
AAAA BBBBB DDDDDD OTHER
XXXX XXXXX XXXXXX XXXXXXX
XXXX XXXXX XXXXXX XXXXXXX
XXXX XXXXX XXXXXX XXXXXXX
Remember to keep the first column in the range, and the last column
(OTHER). OTHER is for temporary labels (a destination that will
only be used once, etc.).
Also, the first data value in each range should be changed (from
my data to yours).
STARTING DESTINATION
--------------------
(BP2 & 4)
Change values in range BP2 to the Main location you usuallly
start from (This will be the range name that shows up in
the macro when choosing--Keep it relatively short)
Change values in range BP4 to the Main location you usuallly
start from (This will be the range name that shows up when
printing--Again keep it short)
******** Remember to keep the labels and only **********
change the Address location data!
ENDING DESTINATION
------------------
(BP10 & 12)
Change values in range BP10 to the Main location you usuallly
end at (This will be the range name that shows up in the macro
when choosing--Keep it relatively short)
Change values in range BP12 to the Main location you usuallly
end at (This will be the range name that shows up when
printing--Again keep it short)
******** Remember to keep the labels and only **********
change the Address location data!
ROUTE TAKEN
-----------
(BP16 & 18)
Change values in range BP16 to the Main Route you usuallly
take (This will be the range name that shows up in the macro
when choosing--Keep it relatively short)
Change values in range BP18 to the Main Route you usuallly
take (This will be the range name that shows up when
printing--Again keep it short)
******** Remember to keep the labels and only **********
change the Address location data!
BIKE USED
---------
(BP22 & 24)
Change values in range BP22 to the Main BIKE you usuallly
use (This will be the range name that shows up in the macro
when choosing--Keep it relatively short)
Change values in range BP24 to the Main BIKE you usuallly
use (This will be the range name that shows up when
printing--Again keep it short)
******** Remember to keep the labels and only **********
change the Address location data!
┌──────────────┐
│PRINTING SETUP│
└──────────────┘
If your printer will not print in condensed mode, the blank log
(for printing a blank log to recording data in) and Text Report
printouts will not fit on a page. You will have to:
BLANK LOG
1) Edit the Range CJ1 to DC3 so that it will fit into a printout
of your printer. This may involve removing info or reducing
items. I you do not want to print out a blank log, then this
is not needed.
TEXT REPORT
If your printer willl not print in condensed mode, doing the
following will print all the relative data but will not print the
starting, ending, route, and weather info.
1) Change Range B8. There is a spot that says {R 12} telling
lotus to go right 12 columns. Change this to {R 7}.
********* NOTE: TO DO ANY OF THE ABOVE CHANGES (or ***********
just get out of the macro in general) type
ESC to get out of the macro. To return to
the macro type ALT-M
╔══════════════════════════════════════════════════════════════╗
║ USING BIKELOG ║
╚══════════════════════════════════════════════════════════════╝
When the program is first called up, a main menu will appear. Just
move to the desired function and press RETURN
ADD --- To add info on new rides (Bikelog automatically sorts
based on date so go ahead and add em out of chronological
order if you have to). Note, I recommend printing out a
BlankLog so you can record the data right after your ride
and then use this to add info into the worksheet).
DELETING RIDE DATA
If any rides data is not desired, DO NOT DELETE A ROW
since this may also delete part of the macros. Instead
erase the range of data that is not wanted (each row
contains one ride--delete a whole ride at a time) Again,
highlight the range and do not erase any of the macros.
If any data follows the range just erased, move all the
data that follows up until it meets the other data.
THERE CAN BE NO EMPTY ROWS OF DATA.
TReport - To get a printout of all riding activity. (See above if
your printer will not print in condensed mode).
GReport - To View 6 Graphs on screen of your Riding info.
****** NOTE ******:
YOU MUST HAVE ADDED AT LEAST TWO RIDES TO GET GRAPHS OR
ERRORS WILL OCCUR.
Edit ---- To ADD new starting destinations, ending destinations,
Routes, Bikes. This will not delete and the first value
of each has to be set manually (see Getting started above
for this).
Gear Calc Enter the number of teeth on front and rear gears and
this will calculate the ratios (so you can plan which
gears are most efficient to use and in what order to
shift).
PrBlnkLog This will print a blank log so you can record ride info
quickly, and then enter many rides into worksheet at one
sitting of the computer.
Save ---- Save the worksheet, but stay in the worksheet to do
something else.
QUIT ---- Save and exit the worksheet.